package jdbc;

public class SQL {

    public static SQL getSQL() {
        return new SQL();
    }

    public String getAddSql() {
        String addSql = "insert into customer(id,name,gender,age,phone,email) values(?,?,?,?,?,?)";

        return addSql;
    }

    public String getUpdateSql() {
        String updateSql = "update customer set name = ?  , gender = ?,age = ? , phone = ? , email = ?  where id = ? ";

        return updateSql;
    }


    public String getDeleteSql() {
        String deleteSql = "delete from customer where id = ?";

        return deleteSql;
    }


    public String getFindAllCustomer() {
        String findAllCustomer = "select * from customer";

        return findAllCustomer;
    }

    public String getFindOneCustomer() {
        String findOneCustomer = "select * from customer where id = ? ";

        return findOneCustomer;
    }

    public String getFindAnyCustomer(){
        String findOneCustomer = "select * from customer limit ?,?";

        return findOneCustomer;
    }


}
